Create ODS Layer Database

The following steps will help you to create an ODS database.

Open Microsoft SQL Server Management Studio.
Right Click on Database ==> Click on New Database.
New Database dialog box appears ==> Then, give a name for your new database.
Click Ok to create a new database.
Click on the plus sign next to the database on object explorer ==> Located newly created database. If you don't see the newly created database, then Right Click on database ==> Click on refresh from the popup dialog box.

Download the SQL file attached above

Locate the downloaded file and double click to open it. It will open in Microsoft SQL Server management studio.
Click Execute to create the following tables.

Dictionary_Incident_Location

Dictionary_Incident_Place

Dictionary_Shooter

Dictionary_Shooter_History_Of_Mental_Illness

dbo].[Dictionary_Shooter_Status

dbo].[Dictionary_Shooters_Motive

Dictionary_Trageted_Victim

Dictionary_Weapons

tbl_Mass_Shooting_ODS